DBA Data[Home] [Help]

APPS.IBE_M_AUTOPLACEMENT_PVT dependencies on FND_MESSAGE

Line 53: fnd_message.set_name('IBE','IBE_M_ADDED_PRMT');

49: l_title1 VARCHAR2(2000);
50: l_add VARCHAR2(100);
51: l_remove VARCHAR2(100);
52: BEGIN
53: fnd_message.set_name('IBE','IBE_M_ADDED_PRMT');
54: l_temp_msg := fnd_message.get;
55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;

Line 54: l_temp_msg := fnd_message.get;

50: l_add VARCHAR2(100);
51: l_remove VARCHAR2(100);
52: BEGIN
53: fnd_message.set_name('IBE','IBE_M_ADDED_PRMT');
54: l_temp_msg := fnd_message.get;
55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);

Line 56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');

52: BEGIN
53: fnd_message.set_name('IBE','IBE_M_ADDED_PRMT');
54: l_temp_msg := fnd_message.get;
55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;

Line 57: l_temp_msg := fnd_message.get;

53: fnd_message.set_name('IBE','IBE_M_ADDED_PRMT');
54: l_temp_msg := fnd_message.get;
55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);

Line 59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');

55: l_add := substr(l_temp_msg,1,100);
56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;

Line 60: l_temp_msg := fnd_message.get;

56: fnd_message.set_name('IBE','IBE_M_REMOVED_PRMT');
57: l_temp_msg := fnd_message.get;
58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);

Line 62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');

58: l_remove := substr(l_temp_msg,1,100);
59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);
65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;

Line 63: l_temp_msg := fnd_message.get;

59: fnd_message.set_name('IBE','IBE_PRMT_DATE_G');
60: l_temp_msg := fnd_message.get;
61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);
65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);

Line 65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');

61: printOutput(l_temp_msg||': '||g_date);
62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);
65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);
68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');

Line 66: l_temp_msg := fnd_message.get;

62: fnd_message.set_name('IBE','IBE_M_RUNNING_MODE_DESC');
63: l_temp_msg := fnd_message.get;
64: printOutput(l_temp_msg||': '||g_mode);
65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);
68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;

Line 69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');

65: fnd_message.set_name('IBE','IBE_PRMT_PREFERENCES_G');
66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);
68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;
71: printOutput(l_temp_msg||': '||g_start_section);
72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;

Line 70: l_temp_msg := fnd_message.get;

66: l_temp_msg := fnd_message.get;
67: printOutput(l_temp_msg||': '||g_preference);
68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;
71: printOutput(l_temp_msg||': '||g_start_section);
72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);

Line 72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');

68: printOutput('');
69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;
71: printOutput(l_temp_msg||': '||g_start_section);
72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);
75: printOutput('');
76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');

Line 73: l_temp_msg := fnd_message.get;

69: fnd_message.set_name('IBE','IBE_M_STARTING_SECTION_PRMT');
70: l_temp_msg := fnd_message.get;
71: printOutput(l_temp_msg||': '||g_start_section);
72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);
75: printOutput('');
76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');
77: l_temp_msg := fnd_message.get;

Line 76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');

72: fnd_message.set_name('IBE','IBE_M_SELECT_SUB_SECTION_PRMT');
73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);
75: printOutput('');
76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');
77: l_temp_msg := fnd_message.get;
78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');

Line 77: l_temp_msg := fnd_message.get;

73: l_temp_msg := fnd_message.get;
74: printOutput(l_temp_msg||': '||g_include_subsection);
75: printOutput('');
76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');
77: l_temp_msg := fnd_message.get;
78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;

Line 80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');

76: fnd_message.set_name('IBE','IBE_M_SELECT_PRODUCT_PRMT');
77: l_temp_msg := fnd_message.get;
78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;
82: fnd_message.set_name('IBE','IBE_PRMT_TO_G');
83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);

Line 81: l_temp_msg := fnd_message.get;

77: l_temp_msg := fnd_message.get;
78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;
82: fnd_message.set_name('IBE','IBE_PRMT_TO_G');
83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;

Line 82: fnd_message.set_name('IBE','IBE_PRMT_TO_G');

78: printOutput(l_temp_msg||':');
79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;
82: fnd_message.set_name('IBE','IBE_PRMT_TO_G');
83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;
86: IF (g_product_name IS NOT NULL) THEN

Line 83: l_title1 := fnd_message.get;

79: IF (g_start_date IS NOT NULL) OR (g_end_date IS NOT NULL) THEN
80: fnd_message.set_name('IBE','IBE_PRMT_FROM_COLON');
81: l_temp_msg := fnd_message.get;
82: fnd_message.set_name('IBE','IBE_PRMT_TO_G');
83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;
86: IF (g_product_name IS NOT NULL) THEN
87: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');

Line 87: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');

83: l_title1 := fnd_message.get;
84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;
86: IF (g_product_name IS NOT NULL) THEN
87: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');
88: l_temp_msg := fnd_message.get;
89: printOutput(l_temp_msg||': '||g_product_name);
90: END IF;
91: IF (g_product_number IS NOT NULL) THEN

Line 88: l_temp_msg := fnd_message.get;

84: printOutput(l_temp_msg||' '||g_start_date||' '||l_title1||' '||g_end_date);
85: END IF;
86: IF (g_product_name IS NOT NULL) THEN
87: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');
88: l_temp_msg := fnd_message.get;
89: printOutput(l_temp_msg||': '||g_product_name);
90: END IF;
91: IF (g_product_number IS NOT NULL) THEN
92: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');

Line 92: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');

88: l_temp_msg := fnd_message.get;
89: printOutput(l_temp_msg||': '||g_product_name);
90: END IF;
91: IF (g_product_number IS NOT NULL) THEN
92: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
93: l_temp_msg := fnd_message.get;
94: printOutput(l_temp_msg||': '||g_product_number);
95: END IF;
96: IF (g_publish_status IS NOT NULL) THEN

Line 93: l_temp_msg := fnd_message.get;

89: printOutput(l_temp_msg||': '||g_product_name);
90: END IF;
91: IF (g_product_number IS NOT NULL) THEN
92: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
93: l_temp_msg := fnd_message.get;
94: printOutput(l_temp_msg||': '||g_product_number);
95: END IF;
96: IF (g_publish_status IS NOT NULL) THEN
97: fnd_message.set_name('IBE','IBE_M_WEB_PUB_STATUS_PRMT');

Line 97: fnd_message.set_name('IBE','IBE_M_WEB_PUB_STATUS_PRMT');

93: l_temp_msg := fnd_message.get;
94: printOutput(l_temp_msg||': '||g_product_number);
95: END IF;
96: IF (g_publish_status IS NOT NULL) THEN
97: fnd_message.set_name('IBE','IBE_M_WEB_PUB_STATUS_PRMT');
98: l_temp_msg := fnd_message.get;
99: printOutput(l_temp_msg||': '||g_publish_status);
100: END IF;
101: IF (g_product_tbl.count > 0) THEN

Line 98: l_temp_msg := fnd_message.get;

94: printOutput(l_temp_msg||': '||g_product_number);
95: END IF;
96: IF (g_publish_status IS NOT NULL) THEN
97: fnd_message.set_name('IBE','IBE_M_WEB_PUB_STATUS_PRMT');
98: l_temp_msg := fnd_message.get;
99: printOutput(l_temp_msg||': '||g_publish_status);
100: END IF;
101: IF (g_product_tbl.count > 0) THEN
102: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');

Line 102: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');

98: l_temp_msg := fnd_message.get;
99: printOutput(l_temp_msg||': '||g_publish_status);
100: END IF;
101: IF (g_product_tbl.count > 0) THEN
102: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
103: l_temp_msg := fnd_message.get;
104: IF (length(l_temp_msg) >= 20) THEN
105: l_title1 := substr(l_temp_msg,1,20) || ' ';
106: ELSE

Line 103: l_temp_msg := fnd_message.get;

99: printOutput(l_temp_msg||': '||g_publish_status);
100: END IF;
101: IF (g_product_tbl.count > 0) THEN
102: fnd_message.set_name('IBE','IBE_M_PRODUCT_NUMBER_PRMT');
103: l_temp_msg := fnd_message.get;
104: IF (length(l_temp_msg) >= 20) THEN
105: l_title1 := substr(l_temp_msg,1,20) || ' ';
106: ELSE
107: l_title1 := RPAD(l_temp_msg,20,' ')||' ';

Line 109: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');

105: l_title1 := substr(l_temp_msg,1,20) || ' ';
106: ELSE
107: l_title1 := RPAD(l_temp_msg,20,' ')||' ';
108: END IF;
109: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');
110: l_temp_msg := fnd_message.get;
111: IF (length(l_temp_msg) >= 40) THEN
112: l_title1 := l_title1 || substr(l_temp_msg,1,40);
113: ELSE

Line 110: l_temp_msg := fnd_message.get;

106: ELSE
107: l_title1 := RPAD(l_temp_msg,20,' ')||' ';
108: END IF;
109: fnd_message.set_name('IBE','IBE_PRMT_ITM_NAME_G');
110: l_temp_msg := fnd_message.get;
111: IF (length(l_temp_msg) >= 40) THEN
112: l_title1 := l_title1 || substr(l_temp_msg,1,40);
113: ELSE
114: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';

Line 116: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');

112: l_title1 := l_title1 || substr(l_temp_msg,1,40);
113: ELSE
114: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
115: END IF;
116: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
117: l_temp_msg := fnd_message.get;
118: IF (length(l_temp_msg) >= 7) THEN
119: l_title1 := l_title1 || substr(l_temp_msg,1,7);
120: ELSE

Line 117: l_temp_msg := fnd_message.get;

113: ELSE
114: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
115: END IF;
116: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
117: l_temp_msg := fnd_message.get;
118: IF (length(l_temp_msg) >= 7) THEN
119: l_title1 := l_title1 || substr(l_temp_msg,1,7);
120: ELSE
121: l_title1 := l_title1 || RPAD(l_temp_msg,7,' ')||' ';

Line 123: fnd_message.set_name('IBE','IBE_PRMT_SECTION_NAME_G');

119: l_title1 := l_title1 || substr(l_temp_msg,1,7);
120: ELSE
121: l_title1 := l_title1 || RPAD(l_temp_msg,7,' ')||' ';
122: END IF;
123: fnd_message.set_name('IBE','IBE_PRMT_SECTION_NAME_G');
124: l_temp_msg := fnd_message.get;
125: IF (length(l_temp_msg) >= 40) THEN
126: l_title1 := l_title1 || substr(l_temp_msg,1,40);
127: ELSE

Line 124: l_temp_msg := fnd_message.get;

120: ELSE
121: l_title1 := l_title1 || RPAD(l_temp_msg,7,' ')||' ';
122: END IF;
123: fnd_message.set_name('IBE','IBE_PRMT_SECTION_NAME_G');
124: l_temp_msg := fnd_message.get;
125: IF (length(l_temp_msg) >= 40) THEN
126: l_title1 := l_title1 || substr(l_temp_msg,1,40);
127: ELSE
128: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';

Line 130: fnd_message.set_name('IBE','IBE_PRMT_SECTION_CODE');

126: l_title1 := l_title1 || substr(l_temp_msg,1,40);
127: ELSE
128: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
129: END IF;
130: fnd_message.set_name('IBE','IBE_PRMT_SECTION_CODE');
131: l_temp_msg := fnd_message.get;
132: l_title1 := l_title1 || l_temp_msg;
133: printOutput(l_title1);
134: -- printOutput('Product Number '||

Line 131: l_temp_msg := fnd_message.get;

127: ELSE
128: l_title1 := l_title1 || RPAD(l_temp_msg,40,' ')||' ';
129: END IF;
130: fnd_message.set_name('IBE','IBE_PRMT_SECTION_CODE');
131: l_temp_msg := fnd_message.get;
132: l_title1 := l_title1 || l_temp_msg;
133: printOutput(l_title1);
134: -- printOutput('Product Number '||
135: -- 'Product Name '||